Quiz: Table Calculations

Tasks to complete:

Task List:

Assure you are working with a clean worksheet.

Move Profit to the Rows and Market to the Columns. Sort your bar chart from highest to lowest.

Select the drop down associated with SUM(Profit) and select Quick Table Calculation > Percent of Total.

Quiz 1 below.

Create a new worksheet.

Make sure Order Date is continuous, and move it to the Columns. Move Sales to the Rows.

Drill down to the Quarter, and change the Sales to look at the Quick Table Calculation > Percent Difference.

Move Category to the Color portion of the Marks table.

Quiz 2 below.

Nice job!

SOLUTION:

Using `Percent of Total` is better for cases when you want to know the proportion of total profits that went to each market.

SOLUTION:

All the categories tend to follow similar quarterly trends?
From Q1 to Q2 tends to have the largest positive percent change for sales.
From Q4 of the previous year to Q1 of the next year tends to have the largest negative percent change for sales.